002
SELECT contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes FROM contentDB,siteScenes WHERE contentDB.contentID=siteScenes.contentID AND contentDB.contentID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,22,78,88,92,120,126,132,137,142,159,160,161,162,170,180,184,185,186,190,195,198,206,207,208,209,244,246,247,248,249,250,269,271,278,283,284,286,287,288,290,291,292,293,294,295,296,297,298,299,304,313,325,345,346,347,348) AND siteScenes.status='active' AND contentDB.mediaType=1 AND contentDB.cgID IN (1) AND contentDB.cgID>0 ORDER BY siteScenes.schedStart desc LIMIT -1,8
simpleQuery("contentDB,siteScenes","contentDB.contentID,contentDB.bookID,contentDB.sceneID,contentDB.mediaType,contentDB.mediaInfo,contentDB.webAllowed,contentDB.webAllowed2,contentDB.clientAllowed,contentDB.dvdAllowed,contentDB.tbProd,contentDB.type,contentDB.sceneType,contentDB.dateAdded,contentDB.name,contentDB.prodNotes,contentDB.prodDate,contentDB.backup,contentDB.story,contentDB.nickname,contentDB.folderName,contentDB.fileID,contentDB.searchKeys,contentDB.extURL,contentDB.cgID,contentDB.schedSeq,contentDB.picsComplete,contentDB.picsUploaded,contentDB.vidsUploaded,contentDB.vidsComplete,contentDB.contentNotes,contentDB.dueDate,contentDB.x2257,contentDB.captured,contentDB.dvdID,contentDB.pics,contentDB.vids,contentDB.recieved,contentDB.recDate,contentDB.shipped,contentDB.shipDate,contentDB.note1,siteScenes.ssID,siteScenes.siteID,siteScenes.contentID,siteScenes.sceneNum,siteScenes.status,siteScenes.schedStart,siteScenes.schedEnd,siteScenes.story,siteScenes.short,siteScenes.nickname,siteScenes.currentlyFeat,siteScenes.oemFeat,siteScenes.promotional,siteScenes.onSale,siteScenes.dateAdded,siteScenes.pageClass,siteScenes.wmView,siteScenes.lockClass,siteScenes.totalClicks,siteScenes.resClicks,siteScenes.avgClicks,siteScenes.votes","WHERE contentDB.contentID=siteScenes.contentID AND contentDB.contentID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,22,78,88,92,120,126,132,137,142,159,160,161,162,170,180,184,185,186,190,195,198,206,207,208,209,244,246,247,248,249,250,269,271,278,283,284,286,287,288,290,291,292,293,294,295,296,297,298,299,304,313,325,345,346,347,348) AND siteScenes.status='active' AND contentDB.mediaType=1 AND contentDB.cgID IN (1) AND contentDB.cgID>0","ORDER BY siteScenes.schedStart desc LIMIT -1,8")
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,8' at line 1